package com.erp.app.common.attachment.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.erp.framework.exceptions.FindRecordException;
import com.erp.framework.model.dao.SimpleSearchMaintStyleDao;
import com.erp.framework.model.vo.ChildList;
import com.erp.framework.model.vo.SimpleBaseVo;

public class AttachmentDao extends SimpleSearchMaintStyleDao{

	protected SimpleBaseVo getResultSetValues(ResultSet rs) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public ChildList selectByParent(SimpleBaseVo parent, Connection conn) throws FindRecordException {
		// TODO Auto-generated method stub
		return null;
	}

	protected void setValuesForDelete(PreparedStatement pStmt, Object obj) throws SQLException {
		// TODO Auto-generated method stub

	}

	protected void setValuesForFind(PreparedStatement pStmt, Object obj) throws SQLException {
		// TODO Auto-generated method stub

	}

	protected void setValuesForInsert(PreparedStatement pStmt, Object obj) throws SQLException {
		// TODO Auto-generated method stub

	}

	protected void setValuesForList(PreparedStatement pStmt, Object obj) throws SQLException {
		// TODO Auto-generated method stub

	}

	protected void setValuesForModify(PreparedStatement pStmt, Object obj) throws SQLException {
		// TODO Auto-generated method stub

	}

	protected String sqlDelete() {
		// TODO Auto-generated method stub
		return null;
	}

	protected String sqlFind() {
		String sql = "SELECT COMPANY_CODE, DOC_CODE, DOC_LINE_NO, ATTACHMENT_LINE_NO, ATTACHMENT_DESC, "
			 +"CONTENT_TYPE, FILE_NAME,ATTACHMENT, CREATE_USER, "
			+ "CREATE_DATE, UPDATE_USER, UPDATE_DATE, DC_IND, DC_DATE "
			+ "FROM V_ATTACHMENT "
			+ "WHERE COMPANY_CODE=? AND DOC_CODE=? AND DOC_LINE_NO=? "
			+ "ORDER BY COMPANY_CODE, DOC_CODE, DOC_LINE_NO";
		return sql;
	}

	protected String sqlInsert() {
		// TODO Auto-generated method stub
		return null;
	}

	protected String sqlList() {
		String sql = "SELECT COMPANY_CODE, DOC_CODE, DOC_LINE_NO, ATTACHMENT_LINE_NO, ATTACHMENT_DESC, "
		    + "CONTENT_TYPE, FILE_NAME,ATTACHMENT, CREATE_USER, "
			+ "CREATE_DATE, UPDATE_USER, UPDATE_DATE, DC_IND, DC_DATE "
			+ "FROM V_ATTACHMENT "
			+ "WHERE COMPANY_CODE=? AND DOC_CODE=?  "
			+ "ORDER BY COMPANY_CODE, DOC_CODE ";
		return sql;
	}

	protected String sqlUpdate() {
		// TODO Auto-generated method stub
		return null;
	}

}
